using System;
using System.Data;
using System.Data.Sql;
using System.Data.SqlClient;
using System.Collections.Generic;
using System.Text;

namespace StudentManagementApplication.Business
{
    public class FeeService : DAO.BaseDAO
    {
        private DAO.FeeDAO feeDAO = new DAO.FeeDAO();

        public void InsertFee(Entities.Fee fee)
        {
            feeDAO.InsertFee(fee);
        }

        public void UpdateFee(Entities.Fee fee)
        {
            feeDAO.UpdateFee(fee);
        }

        public void DeleteFee(String sStudentID)
        {
            feeDAO.DeleteFee(sStudentID);
        }

        public Entities.Fee GetFeeByStudentID(string sStudentID)
        {
            return feeDAO.GetFeeByStudentID(sStudentID);
        }

        public List<Entities.Fee> GetAllFees()
        {
            return feeDAO.GetAllFees();
        }

        public DataTable GetAllFees2()
        {
            return feeDAO.GetAllFees2();
        }

        public DataTable GetFeeByStatus(int iStatus)
        {
            return feeDAO.GetFeeByStatus(iStatus);
        }

        public DataTable GetFeeByClassID(string sClassID)
        {
            return feeDAO.GetFeeByClassID(sClassID);
        }

        public DataTable GetFeeByStatusAndClassID(int iFeePaid, string sClassID)
        {
            return feeDAO.GetFeeByStatusAndClassID(iFeePaid, sClassID);
        }
    }
}
